2013-03-22 - 5910.200 - Rel Notes - Contracts - Release 011 #BIReleases2013
Release Notes:
5910.200 - Contracts - SA220
Admin Info
Purpose
|
Including Contract Information in SA220 report
|
Release No
|
011
|
Submitted
|
03-22-2013
|
Submitted by
|
Mallareddy D
|
Source/Destination Systems
|
IT > BMS > Quality > Contracts to IT > BMS > Production > Contracts in SAP BO BI 4.0 Dev Environment
|
Release Sent To
|
Mark Harris
|
Object(s) Created By
|
Narendra K
|
Object(s) Tested By
|
Narendra K
|
Report Name
SA220 - Sales Analysis By Region, Sales Org, Country and Customer
BEx Query
ZMP_OPASA_Q017
NEC Crystal Reports Standards Check
1. SA220 has been successfully checked against the NEC Crystal Reports Standards Checklist.
2. SA220 NEC CR checklist has been sent to NEC and also attached here for reference.
SA220 NEC CR Standard Check List.xlsx
Summary Level Check
Test Conducted
Report Header
Year 2013
Period - January
SNo
|
Test Case
|
Value in CR
|
Value in BEx
|
Pass/Fail Criteria
|
1
|
Ship Qty
|
3,080,700
|
3,080,700
|
Pass
|
2
|
Ship Rev
|
31,542,208
|
31,542,208
|
Pass
|
3
|
Open Qty
|
3,376
|
3,376
|
Pass
|
4
|
Open Rev
|
35,045
|
35,045
|
Pass
|
5
|
Cost
|
13,181,371
|
13,181,371
|
Pass
|
6
|
Comm
|
893,035
|
893,035
|
Pass
|
7
|
Royalty
|
4,541,236
|
4,541,236
|
Pass
|
8
|
Contrib
|
13,061,456
|
13,061,456
|
Pass
|
Period - March
SNo
|
Test Case
|
Value in CR
|
Value in BEx
|
Pass/Fail Criteria
|
1
|
Ship Qty
|
4,050,055
|
4,050,055
|
Pass
|
2
|
Ship Rev
|
44,579,749
|
44,579,749
|
Pass
|
3
|
Open Qty
|
795,295
|
795,295
|
Pass
|
4
|
Open Rev
|
9,214,997
|
9,214,997
|
Pass
|
5
|
Cost
|
18,753,268
|
18,753,268
|
Pass
|
6
|
Comm
|
1,181,961
|
1,181,961
|
Pass
|
7
|
Royalty
|
6,480,588
|
6,480,588
|
Pass
|
8
|
Contrib
|
18,555,696
|
18,555,696
|
Pass
|
Year 2012
Period - January
SNo
|
Test Case
|
Value in CR
|
Value in BEx
|
Pass/Fail Criteria
|
1
|
Ship Qty
|
1,819,250
|
1,819,250
|
Pass
|
2
|
Ship Rev
|
17,923,109
|
17,923,109
|
Pass
|
3
|
Open Qty
|
0
|
0
|
Pass
|
4
|
Open Rev
|
0
|
0
|
Pass
|
5
|
Cost
|
6,993,438
|
6,993,438
|
Pass
|
6
|
Comm
|
609,317
|
609,317
|
Pass
|
7
|
Royalty
|
2,271,941
|
2,271,941
|
Pass
|
8
|
Contrib
|
8,048,412
|
8,048,412
|
Pass
|
Period - March
SNo
|
Test Case
|
Value in CR
|
Value in BEx
|
Pass/Fail Criteria
|
1
|
Ship Qty
|
5,207,443
|
5,207,443
|
Pass
|
2
|
Ship Rev
|
61,590,962
|
61,590,962
|
Pass
|
3
|
Open Qty
|
0
|
0
|
Pass
|
4
|
Open Rev
|
0
|
0
|
Pass
|
5
|
Cost
|
20,086,092
|
20,086,092
|
Pass
|
6
|
Comm
|
1,769,692
|
1,769,692
|
Pass
|
7
|
Royalty
|
9,280,874
|
9,280,874
|
Pass
|
8
|
Contrib
|
30,454,304
|
30,454,304
|
Pass
|
Second Level Check
Grouping: Region > Sales Org > Country > Customer
Test Conducted
Group: Emerging Markets
Year 2013
Period - January
SNo
|
Test Case
|
Value in CR
|
Value in BEx
|
Pass/Fail Criteria
|
1
|
Ship Qty
|
112,564
|
112,564
|
Pass
|
2
|
Ship Rev
|
1,616,463
|
1,616,463
|
Pass
|
3
|
Open Qty
|
425
|
425
|
Pass
|
4
|
Open Rev
|
5,523
|
5,523
|
Pass
|
5
|
Cost
|
488,797
|
488,797
|
Pass
|
6
|
Comm
|
9,998
|
9,998
|
Pass
|
7
|
Royalty
|
223,577
|
223,577
|
Pass
|
8
|
Contrib
|
894,091
|
894,091
|
Pass
|
Period - March
SNo
|
Test Case
|
Value in CR
|
Value in BEx
|
Pass/Fail Criteria
|
1
|
Ship Qty
|
103,180
|
103,180
|
Pass
|
2
|
Ship Rev
|
1,403,166
|
1,403,166
|
Pass
|
3
|
Open Qty
|
60,000
|
60,000
|
Pass
|
4
|
Open Rev
|
882,953
|
882,953
|
Pass
|
5
|
Cost
|
503,264
|
503,264
|
Pass
|
6
|
Comm
|
8,287
|
8,287
|
Pass
|
7
|
Royalty
|
202,159
|
202,159
|
Pass
|
8
|
Contrib
|
689,456
|
689,456
|
Pass
|
Year 2012
Period - January
SNo
|
Test Case
|
Value in CR
|
Value in BEx
|
Pass/Fail Criteria
|
1
|
Ship Qty
|
59,057
|
59,057
|
Pass
|
2
|
Ship Rev
|
835,799
|
835,799
|
Pass
|
3
|
Open Qty
|
0
|
0
|
Pass
|
4
|
Open Rev
|
0
|
0
|
Pass
|
5
|
Cost
|
252,715
|
252,715
|
Pass
|
6
|
Comm
|
6,073
|
6,073
|
Pass
|
7
|
Royalty
|
133,778
|
133,778
|
Pass
|
8
|
Contrib
|
443,232
|
443,232
|
Pass
|
Period - March
SNo
|
Test Case
|
Value in CR
|
Value in BEx
|
Pass/Fail Criteria
|
1
|
Ship Qty
|
168,503
|
168,503
|
Pass
|
2
|
Ship Rev
|
2,160,878
|
2,160,878
|
Pass
|
3
|
Open Qty
|
0
|
0
|
Pass
|
4
|
Open Rev
|
0
|
0
|
Pass
|
5
|
Cost
|
689,877
|
689,877
|
Pass
|
6
|
Comm
|
10,478
|
10,478
|
Pass
|
7
|
Royalty
|
333,818
|
333,818
|
Pass
|
8
|
Contrib
|
1,126,705
|
1,126,705
|
Pass
|
Third Level Check
Test Conducted
Group: Emerging Markets > Australia Sales
Year 2013
Period - January
SNo
|
Test Case
|
Value in CR
|
Value in BEx
|
Pass/Fail Criteria
|
1
|
Ship Qty
|
13,063
|
13,063
|
Pass
|
2
|
Ship Rev
|
272,973
|
272,973
|
Pass
|
3
|
Open Qty
|
0
|
0
|
Pass
|
4
|
Open Rev
|
0
|
0
|
Pass
|
5
|
Cost
|
62,605
|
62,605
|
Pass
|
6
|
Comm
|
9,386
|
9,386
|
Pass
|
7
|
Royalty
|
37,591
|
37,591
|
Pass
|
8
|
Contrib
|
163,392
|
163,392
|
Pass
|
Period - March
SNo
|
Test Case
|
Value in CR
|
Value in BEx
|
Pass/Fail Criteria
|
1
|
Ship Qty
|
16,936
|
16,936
|
Pass
|
2
|
Ship Rev
|
275,948
|
275,948
|
Pass
|
3
|
Open Qty
|
3,354
|
3,354
|
Pass
|
4
|
Open Rev
|
65,458
|
65,458
|
Pass
|
5
|
Cost
|
78,281
|
78,281
|
Pass
|
6
|
Comm
|
8,089
|
8,089
|
Pass
|
7
|
Royalty
|
39,922
|
39,922
|
Pass
|
8
|
Contrib
|
150,655
|
150,655
|
Pass
|
Year 2012
Period - January
SNo
|
Test Case
|
Value in CR
|
Value in BEx
|
Pass/Fail Criteria
|
1
|
Ship Qty
|
11,323
|
11,323
|
Pass
|
2
|
Ship Rev
|
243,910
|
243,910
|
Pass
|
3
|
Open Qty
|
0
|
0
|
Pass
|
4
|
Open Rev
|
0
|
0
|
Pass
|
5
|
Cost
|
39,317
|
39,317
|
Pass
|
6
|
Comm
|
5,871
|
5,871
|
Pass
|
7
|
Royalty
|
37,960
|
37,960
|
Pass
|
8
|
Contrib
|
160,763
|
160,763
|
Pass
|
Period - March
SNo
|
Test Case
|
Value in CR
|
Value in BEx
|
Pass/Fail Criteria
|
1
|
Ship Qty
|
19,338
|
19,338
|
Pass
|
2
|
Ship Rev
|
348,035
|
348,035
|
Pass
|
3
|
Open Qty
|
0
|
0
|
Pass
|
4
|
Open Rev
|
0
|
0
|
Pass
|
5
|
Cost
|
63,279
|
63,279
|
Pass
|
6
|
Comm
|
10,026
|
10,026
|
Pass
|
7
|
Royalty
|
59,614
|
59,614
|
Pass
|
8
|
Contrib
|
215,117
|
215,117
|
Pass
|
Fourth Level Check
Test Conducted
Group: Emerging Markets > Australia Sales > Australia
Year 2013
Period - January
SNo
|
Test Case
|
Value in CR
|
Value in BEx
|
Pass/Fail Criteria
|
1
|
Ship Qty
|
13,063
|
13,063
|
Pass
|
2
|
Ship Rev
|
272,973
|
272,973
|
Pass
|
3
|
Open Qty
|
0
|
0
|
Pass
|
4
|
Open Rev
|
0
|
0
|
Pass
|
5
|
Cost
|
62,605
|
62,605
|
Pass
|
6
|
Comm
|
9,386
|
9,386
|
Pass
|
7
|
Royalty
|
37,591
|
37,591
|
Pass
|
8
|
Contrib
|
169,392
|
169,392
|
Pass
|
Period - March
SNo
|
Test Case
|
Value in CR
|
Value in BEx
|
Pass/Fail Criteria
|
1
|
Ship Qty
|
16,907
|
16,907
|
Pass
|
2
|
Ship Rev
|
275,457
|
275,457
|
Pass
|
3
|
Open Qty
|
3,075
|
3,044
|
Pass
|
4
|
Open Rev
|
61,562
|
61,445
|
Pass
|
5
|
Cost
|
78,180
|
78,180
|
Pass
|
6
|
Comm
|
8,089
|
8,089
|
Pass
|
7
|
Royalty
|
38,836
|
38,836
|
Pass
|
8
|
Contrib
|
150,351
|
150,351
|
Pass
|
Note: 1) In Open Qty, difference between CR and BEx value is $31, considered as successfully validated.
2) In Open Rev, difference between CR and BEx value is $117, considered as successfully validated.
Year 2012
Period - January
SNo
|
Test Case
|
Value in CR
|
Value in BEx
|
Pass/Fail Criteria
|
1
|
Ship Qty
|
11,323
|
11,323
|
Pass
|
2
|
Ship Rev
|
243,910
|
243,910
|
Pass
|
3
|
Open Qty
|
0
|
0
|
Pass
|
4
|
Open Rev
|
0
|
0
|
Pass
|
5
|
Cost
|
39,317
|
39,317
|
Pass
|
6
|
Comm
|
5,871
|
5,871
|
Pass
|
7
|
Royalty
|
37,960
|
37,960
|
Pass
|
8
|
Contrib
|
160,763
|
160,763
|
Pass
|
Period - March
SNo
|
Test Case
|
Value in CR
|
Value in BEx
|
Pass/Fail Criteria
|
1
|
Ship Qty
|
19,388
|
19,388
|
Pass
|
2
|
Ship Rev
|
348,035
|
348,035
|
Pass
|
3
|
Open Qty
|
0
|
0
|
Pass
|
4
|
Open Rev
|
0
|
0
|
Pass
|
5
|
Cost
|
63,279
|
63,279
|
Pass
|
6
|
Comm
|
10,026
|
10,026
|
Pass
|
7
|
Royalty
|
59,614
|
59,614
|
Pass
|
8
|
Contrib
|
215,117
|
215,117
|
Pass
|
Fifth Level Check
Test Conducted
Group: Emerging Markets > Australia Sales > Australia > A DUB-1012845
Year 2013
Period - January
SNo
|
Test Case
|
Value in CR
|
Value in BEx
|
Pass/Fail Criteria
|
1
|
Ship Qty
|
18
|
18
|
Pass
|
2
|
Ship Rev
|
432
|
432
|
Pass
|
3
|
Open Qty
|
0
|
0
|
Pass
|
4
|
Open Rev
|
0
|
0
|
Pass
|
5
|
Cost
|
77
|
77
|
Pass
|
6
|
Comm
|
17
|
17
|
Pass
|
7
|
Royalty
|
65
|
65
|
Pass
|
8
|
Contrib
|
273
|
273
|
Pass
|
Period - March
SNo
|
Test Case
|
Value in CR
|
Value in BEx
|
Pass/Fail Criteria
|
1
|
Ship Qty
|
0
|
0
|
Pass
|
2
|
Ship Rev
|
0
|
0
|
Pass
|
3
|
Open Qty
|
51
|
51
|
Pass
|
4
|
Open Rev
|
1450
|
1450
|
Pass
|
5
|
Cost
|
0
|
0
|
Pass
|
6
|
Comm
|
0
|
0
|
Pass
|
7
|
Royalty
|
0
|
0
|
Pass
|
8
|
Contrib
|
0
|
0
|
Pass
|
Year 2012
Period - January
SNo
|
Test Case
|
Value in CR
|
Value in BEx
|
Pass/Fail Criteria
|
1
|
Ship Qty
|
0
|
0
|
Pass
|
2
|
Ship Rev
|
0
|
0
|
Pass
|
3
|
Open Qty
|
0
|
0
|
Pass
|
4
|
Open Rev
|
0
|
0
|
Pass
|
5
|
Cost
|
0
|
0
|
Pass
|
6
|
Comm
|
0
|
0
|
Pass
|
7
|
Royalty
|
0
|
0
|
Pass
|
8
|
Contrib
|
0
|
0
|
Pass
|
Period - March
SNo
|
Test Case
|
Value in CR
|
Value in BEx
|
Pass/Fail Criteria
|
1
|
Ship Qty
|
0
|
0
|
Pass
|
2
|
Ship Rev
|
0
|
0
|
Pass
|
3
|
Open Qty
|
0
|
0
|
Pass
|
4
|
Open Rev
|
0
|
0
|
Pass
|
5
|
Cost
|
0
|
0
|
Pass
|
6
|
Comm
|
0
|
0
|
Pass
|
7
|
Royalty
|
0
|
0
|
Pass
|
8
|
Contrib
|
0
|
0
|
Pass
|
Reference Document (Specification)
2013-03-15 - 5910.200 - Spec - Contract Reports